Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | RetailTransaction(TR_RTL) |
CreateDateTime | The time-date this RetailTransactionSalesReceipImage instance was created. Note that sales receipts MAY NOT be altered after a transaction is posted. If necessary the transaction may be VOIDED and recreated. | DT_CRT_DT_TM | Datetime | datetime | |
SalesReciptImageFileURI | Universal Resource Identifier that points to the source where the retail sales receipt is stored. | URI_SLS_RCT_IMG_FLE | DescriptionShort | varchar(255) | |
SalesReceiptImageBlob | A binary large object used to store a sales receipt image within the database. This is provided as an option for really small receipts or retailers with low sales receipt volume. As a rule, retailers will use the URI attribute to reference the digital image file which resides outside the relational database. | BM_SLS_RCT_IMG | Blob | varbinary | |